﻿CREATE TABLE [dbo].[ContactDetail] (
    [ContactDetailID] UNIQUEIDENTIFIER NOT NULL,
    [CreatedDate]     DATETIME         NOT NULL,
    [CreatedBy]       UNIQUEIDENTIFIER NOT NULL,
    [ModifiedDate]    DATETIME         NOT NULL,
    [ModifiedBy]      UNIQUEIDENTIFIER NOT NULL,
    [Deleted]         BIT              NOT NULL,
    [HomeNumber]      VARCHAR (24)     NOT NULL,
    [MobileNumber]    VARCHAR (24)     NOT NULL,
    [WorkNumber]      VARCHAR (24)     NOT NULL,
    [FaxNumber]       VARCHAR (24)     NOT NULL,
    [EmailAddress]    VARCHAR (128)    NOT NULL
);

